Holiday Award
Award holiday hours regardless of whether an employee works or not on a holiday (e.g. award 8hrs HOL). Includes options for requiring positive attendance around the holiday, observing on the nearest weekday, and observing on the nearest scheduled day.
Details
Rule Type
Time
Execution
After day
Parameters
| Name | DataType | DefaultValue | Description |
|---|---|---|---|
Hour type | lookup | The earnings code to use for the awarded holiday hours | |
Days of service | integer | 0 | The number of days of service before holiday is awarded (e.g. 90 days) |
Hours to award | integer | 8 | Number of hours to award on the holiday (default 8) |
No absence | boolean | False | If enabled, must have worked the last shift before and first shift after the holiday, including the holiday itself in order to receive the holiday award (shifts can be up to 5 days in either direction) |
Observe on weekdays | boolean | False | If enabled, holidays which fall on a weekend will be observed on the nearest week day (e.g. Sat->Fri, Sun->Mon), |
Decision Tree
Rule processing begins in the cell R1:Level1 and proceeds right/down. Any IF statement which results in a DONE step terminates the rule immediately.
| Line# | Level1 | Level2 | Level3 | Comment |
|---|---|---|---|---|
| 1 | Start | |||
| 2 | IF(IS_HOLIDAY(PayDate, Observe on weekdays) = 0) → | ↓ | See if the current date is a holiday (accounting for weekends and schedules if those options are enabled) | |
| 3 | ↓ | DONE | ||
| 4 | IF(DATE_DIFF(PayDate, FIND(Employee, HireDate)) < Days of service) → | ↓ | Check the service length of employment | |
| 5 | ↓ | DONE | ||
| 6 | SET( = INSERT_PUNCH(PayDate, Hour type, Hours to award)) | Award the bulk hour amount | ||
| 7 | DONE |